Creating KPI's and the Slicer 11

Create Year Slicer and KPI's

-         Double click on the Slicer Icon On the visualization bar.

-         Slicer visual will display on the report.

-         For the filed please select Year under Date Table

-         Go to Format, click General, Y position = 0 width =211, height = 102

-         Click on the title and title text write Year

-         Chose font color as White, and title color as dark brown # 6d5900




CCreate YoY KPI card.

1.   Double click on the Card Icon on the visualization bar.

2.   Card visual will display on the report

3.   Drag and drop the YoY column from H-1B Visa Table

4. Click format, on Y position=0 Width=212, Height = 101

5. Click on Title, title box put YoY, change font color to white, background brown # 6d5900, center it, text size 14



Create Approved Cases KPI

          1.   Double click on the Card Icon on the visualization bar.

2.   Card visual will display on the report

3.   Drag and drop the Approved Cases column from H-1B Visa Table

4. Click format, on Y position=0 Width 212, Height = 102

5. Click on Title, title box put Approved Cases, change font color to white, background brown # 6d5900, center it, text size 14



   

Create Total Cases KPI

          1.   Double click on the Card Icon on the visualization bar.

2.   Card visual will display on the report

3.   Drag and drop the Total Cases column from H-1B Visa Table

4. Click format, on Y position=0 Width 212, Height = 102

5. Click on Title, title box put Approved Cases, change font color to white, background brown # 6d5900, center it, text size 14

6. Change format to Whole number



Below video is a tutorial on creating slicers:

https://www.youtube.com/watch?v=SA43PwWCilQ

Below Video is a tutorial on creating cards:

https://www.youtube.com/watch?v=DCaPmuXVHH0